@Echo off

rmdir Employees /S /Q
md Employees

copy SetupFiles\Employees1.txt Employees

copy SetupFiles\Employees2.txt Employees

copy SetupFiles\Employees3.txt Employees

attrib +r Employees\Employees*.txt

sqlcmd -i "SetupFiles\HumanResourcesDB.sql"

bcp HumanResources.hr.Employees2 in D:\_MyRoot\SVN\training\SSIS\Mod07\Labfiles\Starter\SetupFiles\EmployeeSample.txt -T -c

bcp HumanResources.hr.Employees3 in D:\_MyRoot\SVN\training\SSIS\Mod07\Labfiles\Starter\SetupFiles\EmployeeSample.txt -T -c
